package com.xt.purchasingsystem.mapper;

import com.xt.purchasingsystem.dto.DFileDto;
import com.xt.purchasingsystem.model.SCell;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface SCellMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(SCell record);

    /**
     * 查询未审核的总数
     * @return
     */
    int rowCountByUnreviewed();

    List<SCell> getAllUnreviewedScell(@Param("currNo") Integer currNo, @Param("pageSize") Integer pageSize);

    int insertSelective(SCell record) ;

    SCell selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(SCell record);

    int updateByPrimaryKey(SCell record);

    /**
     * 根据产品编号查询此产品的库存单元的方法
     * @param productId
     * @return
     */
    SCell getByProductId(@Param("productId") String productId);



}